Tabela Contact

Definicja tabeli Contact

Name

Contact

Code

Contact

Comment

PL: Dane kontaktowe
EN: Contact data – for persons and organization units
DE: Die Tabelle fur die Daten der Person


Lista kolumn tabeli Contact

Name

Code

ContactID

ContactID

ContactTypeID

ContactTypeID

ExternalDoctorID

ExternalDoctorID

ContactName

ContactName

Phone

Phone

CellPhone

CellPhone

AdditionalPhone

AdditionalPhone

Beeper

Beeper

Comments

Comments

Fax

Fax

AnnouncementAgreement

AnnouncementAgreement

DataProsessingAgreement

DataProsessingAgreement

DocNotCollated

DocNotCollated

StartDT

StartDT

StopDT

StopDT

Email

Email

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

Skype

Skype

HideContactFromPatient

HideContactFromPatient

PhoneComments

PhoneComments

CellPhoneComments

CellPhoneComments

EmailComments

EmailComments


Kolumna ContactID tabeli Contact

Definicja kolumny ContactID tabeli Contact

Name

ContactID

Code

ContactID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContactTypeID tabeli Contact

Definicja kolumny ContactTypeID tabeli Contact

Name

ContactTypeID

Code

ContactTypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ExternalDoctorID tabeli Contact

Definicja kolumny ExternalDoctorID tabeli Contact

Name

ExternalDoctorID

Code

ExternalDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContactName tabeli Contact

Definicja kolumny ContactName tabeli Contact

Name

ContactName

Code

ContactName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Phone tabeli Contact

Definicja kolumny Phone tabeli Contact

Name

Phone

Code

Phone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

PL: Numer telefonu
EN: Telephone number
DE: Die Telefonnummer


Kolumna CellPhone tabeli Contact

Definicja kolumny CellPhone tabeli Contact

Name

CellPhone

Code

CellPhone

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna AdditionalPhone tabeli Contact

Definicja kolumny AdditionalPhone tabeli Contact

Name

AdditionalPhone

Code

AdditionalPhone

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna Beeper tabeli Contact

Definicja kolumny Beeper tabeli Contact

Name

Beeper

Code

Beeper

Data Type

VARCHAR2(24)

Mandatory

No

Comment

 


Kolumna Comments tabeli Contact

Definicja kolumny Comments tabeli Contact

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Fax tabeli Contact

Definicja kolumny Fax tabeli Contact

Name

Fax

Code

Fax

Data Type

VARCHAR2(128)

Mandatory

No

Comment

PL: Numer faxu
EN: Fax number
DE: Die Nummer des Fax


Kolumna AnnouncementAgreement tabeli Contact

Definicja kolumny AnnouncementAgreement tabeli Contact

Name

AnnouncementAgreement

Code

AnnouncementAgreement

Data Type

NUMBER(5)

Mandatory

No

Comment

Zgoda na wysylanie komunikatow


Kolumna DataProsessingAgreement tabeli Contact

Definicja kolumny DataProsessingAgreement tabeli Contact

Name

DataProsessingAgreement

Code

DataProsessingAgreement

Data Type

NUMBER(5)

Mandatory

No

Comment

Zgoda na przetwarzanie danych osobowych


Kolumna DocNotCollated tabeli Contact

Definicja kolumny DocNotCollated tabeli Contact

Name

DocNotCollated

Code

DocNotCollated

Data Type

NUMBER(5)

Mandatory

No

Comment

Dokumentacja nie scalona.


Kolumna StartDT tabeli Contact

Definicja kolumny StartDT tabeli Contact

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Contact

Definicja kolumny StopDT tabeli Contact

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Email tabeli Contact

Definicja kolumny Email tabeli Contact

Name

Email

Code

Email

Data Type

VARCHAR2(70)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli Contact

Definicja kolumny InsertingPerson tabeli Contact

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli Contact

Definicja kolumny InsertDate tabeli Contact

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedDT tabeli Contact

Definicja kolumny LastModifiedDT tabeli Contact

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli Contact

Definicja kolumny LastModifiedPerson tabeli Contact

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Skype tabeli Contact

Definicja kolumny Skype tabeli Contact

Name

Skype

Code

Skype

Data Type

VARCHAR2(32)

Mandatory

No

Comment

Kolumna przechowuje identyfikator/login w programie skype w kontekscie lekarza/jednostki org.


Kolumna HideContactFromPatient tabeli Contact

Definicja kolumny HideContactFromPatient tabeli Contact

Name

HideContactFromPatient

Code

HideContactFromPatient

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Kolumna informacyjna dla Eportalu czy ukryc kontakt na liscie dostepnych kontaktów do videokonferencji.


Kolumna PhoneComments tabeli Contact

Definicja kolumny PhoneComments tabeli Contact

Name

PhoneComments

Code

PhoneComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz dotyczacy pola Telefon


Kolumna CellPhoneComments tabeli Contact

Definicja kolumny CellPhoneComments tabeli Contact

Name

CellPhoneComments

Code

CellPhoneComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz dotyczacy pola Telefon komórkowy


Kolumna EmailComments tabeli Contact

Definicja kolumny EmailComments tabeli Contact

Name

EmailComments

Code

EmailComments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Komentarz dotyczacy pola E-mail


Lista kluczy tabeli Contact

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Contact

Definicja klucza Identifier_1 tabeli Contact

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment